• 专利附录
  • 专利说明
  • 权利要求
  • 类似技术
  • 同族专利
  • 引用文献
  • 法律状态
  • 优先权
    • 专利摘要:
    Disclosed herein is a method for generating an engineering database using lookup tables, which includes creating multiple table sets for generating the engineering database, inputting multiple pieces of control information for controlling respective ones of the multiple datasets, and inputting multiple lookup tables corresponding to each of the multiple pieces of control information.
    公开号:SE1651437A1
    申请号:SE1651437
    申请日:2016-11-01
    公开日:2017-05-05
    发明作者:Bae Seung-Ho；Kim Sang-Jin
    申请人:Agency Defense Dev；
    IPC主号:
    专利说明:

    [2] [0002] When a database is generated using lookup tables, the structure of the lookuptable becomes more complicated With an increase in the number of independentvariables, and thus the generation of the database is time-consuming. Also, it isproblematic in that it is necessary to generate different respective databases for variouskinds of independent variables.
    [3] [0003] MeanWhile, an engineering database is configured such that lookup tables thereincontain numeric data and such that the amount of data increases With an increase in the number of independent variables.
    [4] [0004] Accordingly, the present invention has been made keeping in mind the aboveproblem occurring in the conventional art, and an object of the present invention is toprovide a method for generating an engineering database that is capable of flexiblyresponding to the kind and number of independent variables When the database isgenerated based on lookup tables.
    [5] [0005] Another object of the present invention is to provide a method for generating anengineering database that has no limitation as to the kind and number of independentvariables.
    [6] [0006] In order to accomplish the above object, the present invention provides a method for generating an engineering database capable of flexibly responding to the kind and number of independent variables When the database is generated based on lookup tables.[0007] The method for generating an engineering database using lookup tables mayinclude creating multiple table sets for generating an engineering database; inputtingmultiple pieces of control information for controlling respective ones of the multipletable sets; and inputting multiple lookup tables corresponding to each of the multiplepieces of control information.
    [8] [0008] Here, the multiple lookup tables may show data values for a change in a singleindependent Variable.
    [9] [0009] Also, primary input information in Which the multiple pieces of controlinformation are aggregated may be presented in a first level.
    [10] [0010] Also, secondary input information including each of the multiple pieces ofcontrol information for controlling each of the multiple table sets may be presented in asecond level.
    [11] [0011] Also, each of the lookup tables may use dependent variable values for a changein the single independent variable.
    [12] [0012] Also, the primary input information may include a number of the multiple tablesets included in the engineering database and names for referring to respective pieces ofthe control information included in the engineering database.
    [13] [0013] Also, in the second level, values of remaining independent variables, excludingthe single independent variable included in the multiple lookup tables, may be arrangedalong With names of the lookup tables in order to enable the multiple lookup tables to besorted.
    [14] [0014] Also, the secondary input information may include a number of columnscontained in the lookup table, a number of columns selected from among the columnscontained in the lookup table, and column numbers of the selected columns.
    [15] [0015] Also, the secondary input information may include independent variables, anumber and names of variables dependent on the independent variables, and a number ofthe multiple lookup tables.
    [16] [0016] Also, each of the multiple lookup tables may be configured With a combinationof input information for the independent variables and a name of the lookup tablecorresponding to the independent variables.
    [17] [0017] The above and other objects, features and advantages of the present inventionwill be more clearly understood from the following detailed description taken inconjunction with the accompanying drawings, in which:
    [18] [0018] FIG. l is a concept diagram that shows the structure of data in a databaseaccording to an embodiment of the present invention;
    [19] [0019] FIG. 2 is a concept diagram that shows the input of hierarchical inforrnationabout data in the database of FIG. l;
    [20] [0020] FIGS. 3A, 3B, and SC show examples in which the inforrnation about dataaccording to FIG. 2 is input;
    [21] [0021] FIGS. 4A, 4B, 4C, 4D, 4E, and 4F show examples of the content of a lookuptable according to an embodiment of the present invention;
    [22] [0022] FIG. 5 is a flowchart of the process of generating the structure of a databaseaccording to an embodiment of the present invention; and
    [23] [0023] FIG. 6 is a block diagram of a computer device for generating the structure of a database according to an embodiment of the present invention.
    [24] [0024] Because the present invention may be variously changed and may have variousembodiments, specific embodiments will be described in detail below with reference tothe attached drawings. However, it should be understood that those embodiments arenot intended to limit the present invention to specific disclosure forms but include allchanges, equivalents or modifications included in the spirit and scope of the presentinvention.
    [25] [0025] It should be noted that the same reference numerals are used to designate thesame or similar elements throughout the drawings.
    [26] [0026] While terms such as “first” and “second”, etc., may be used to describe variouscomponents, such components must not be understood as being limited to the aboveterms. The above terms are used only to distinguish one component from another.
    [27] [0027] For, example, a first component may be referred to as a second component without departing from the rights of the present invention, and likewise a secondcomponent may be referred to as a first component. The term “and/or” should beunderstood as including all combinations that can be made from one or more relevantitems.
    [28] [0028] Unless differently defined, all terms used here including technical or scientificterms have the same meanings as terms generally understood by those skilled in the artto which the present invention pertains.
    [29] [0029] Terms identical to those defined in generally used dictionaries should beinterpreted as having meanings identical to contextual meanings of the related art, andare not to be interpreted as having ideal or excessively formal meanings unless they aredefinitely defined in the present specification.
    [30] [0030] Hereinafter, a method for generating a database using lookup tables according toan embodiment of the present invention will be described in detail with reference to theaccompanying drawings.
    [31] [0031] FIG. l is a concept diagram that shows the structure of data in a databaseaccording to an embodiment of the present invention. Specifically, FIG. l shows ahierarchical data structure in the database. Referring to FIG. l, the database includes ntable sets from a first table set l00-l to an n-th table set l00-n. In other words, thedatabase includes n table sets, which are referred to as itblset = l, itblset = 2, .., itblset =n, and for each of the table sets, information about the data structure thereof and lookuptables ll0-l to ll0-n may be configured as separate control information, which isreferred to as a control file of tblset l, ..., a control file of tblset n. Here, “itblset”denotes a table set.
    [32] [0032] FIG. 2 is a concept diagram that shows the input of hierarchical data for thedatabase illustrated in FIG. l. Specifically, FIG. 2 is a view that conceptually shows theinput of two levels of hierarchical data. Referring to FIG. 2, the secondary inputinformation for controlling each of the table sets, which corresponds to control files oftblset l to n, is located in the second level, and the primary input information in whichthe pieces of secondary input information are aggregated is located in the first level.[0033] FIGS. 3A, 3B, and 3C are an example of the input of information about dataaccording to FIG. 2. Referring to FIGS. 3A, 3B, and 3C, the database is configured with seven table sets 320, and control information 330 for controlling each of the table sets is represented as “control_f1le_itblset = 01.INP”, ..., “control_f1le_itblset = 07.INP”, asshown in the primary input information.
    [34] [0034] The secondary input information shows the first piece of information, which isreferred to as “control_f1le_itblset = 01.INP”, among the seven pieces of inputinformation. From the secondary input information, information about the first table setmay be confirmed to be the following.
    [35] [0035] FIGS. 4A, 4B, 4C, 4D, 4E, and 4F are examples that show the content of alookup table according to an embodiment of the present inVention. Specifically, FIGS.4A, 4B, 4C, 4D, 4E, and 4F show the content of the lookup table that is referred to as“geo00_m060_A000.dat” illustrated in FIGS. 3A, 3B, and 3C. The lookup tablecontains a total of eight columns. The second column denotes the last independentVariable “Phi”, and the third to eighth columns respectiVely denote six dependentVariables. The first row of the lookup table contains important information fordescribing the lookup table, rather than data. As shown in the drawing, if the row thatcontains information for describing the lookup table (i.e. the first and last rows of the table) may be controlled using an input file, the degree of freedom in the format of the lookup table may be further increased.
    [36] [0036] FIG. 5 is a flowchart that shows the process of generating the structure of adatabase according to an embodiment of the present invention. Referring to FIG. 5, alookup table is generated at step S510 by including a single independent variable and alldependent variables therein.
    [37] [0037] Subsequently, multiple table sets are generated, and control inforrnation forcontrolling each of the multiple table sets is input at step S520.
    [38] [0038] Subsequently, information about independent variables and dependent variablesis generated at step S530, and multiple lookup tables, Which have been created inadvance using a table lookup method, are input in the control information, Whereby thestructure of an engineering database is generated at step S540.
    [39] [0039] FIG. 6 is a block diagram of a computer device for creating a database structureaccording to an embodiment of the present invention. Referring to FIG. 6, the computerdevice 600 includes an input unit 6l0 for handling data and/or user input, a processingunit 620 for processing data and/or input signals, a display unit 640 for displaying theprocessed data, and a storage unit 630 for storing a database 633 that is created based onthe processed data.
    [40] [0040] The input unit 6l0 may be a touch screen, a mouse, a keyboard, a microphone, aLiquid Crystal Display (LCD) panel or the like.
    [41] [0041] The storage unit 630 stores an Operating System (OS) 632 for operating thecomputer device 600, programs for implementing algorithms for creating an engineeringdatabase, data, and the like. Here, the storage unit 630 may be memory Within a CPU(not illustrated) or separate memory. Therefore, the storage unit 630 may be configuredas a combination of non-volatile memory, such as a Solid State Disk (SSD), a hard diskdrive, flash memory, Electrically Erasable Programmable Read-Only Memory(EEPROM), Static RAM (SRAM), Ferro-electric RAM (FRAM), Phase-change RAM(PRAM), Magnetic RAM (MRAM) or the like, and volatile memory, such as DynamicRandom Access Memory (DRAM), Synchronous Dynamic Random Access Memory(SDRAM), Double Data Rate-SDRAM (DDR-SDRRAM) or the like.
    [42] [0042] The database 633 may be configured as a separate database server.
    [43] [0043] According to the present invention, When a database is generated using lookup tables and a table lookup method is used, operations required for interpreting and designing data may be replaced by the process of indexing and interpolating data in apreviously generated database.
    [44] [0044] Also, the present invention may provide a method for maximizing efficiency byusing a table lookup method, Which may improve efficiency as operations that arenecessary in order to interpret and design data are more complicated and more time-consuming.
    [45] [0045] Also, the present invention enables the entire structure of a database (i.e., thenumber and range of independent variables and the kind and number of dependentvariables) to be easily checked, and enables data to be easily reviewed, replaced, andupdated.
    [46] [0046] Also, because the present invention enables the structure of a lookup table to becontrolled through separate input, the format of the lookup table (i.e. the number andorder of roWs and columns therein) is not limited, and the table may be freelyconf1gured.
    [47] [0047] Also, in the present invention, because all remaining independent variables,excluding the last independent variable, are separately input, data may be sorted basedon each of the independent variables, Whereby there is no need to sort data files for eachindependent variable.
    [48] [0048] Also, the present invention may enable easy generation of a database When thedependent variables are the same but the kinds of independent variables are differentfrom each other.
    权利要求:
    Claims (8)
    [1] 1. l. A method for generating an engineering database using lookup tables,comprising: creating multiple table sets for generating an engineering database; inputting multiple pieces of control information for controlling the multiple tablesets, respectively; and inputting multiple lookup tables corresponding to each of the multiple pieces ofcontrol information, Wherein the multiple lookup tables show data values for a change in a single independent Variable.
    [2] 2. The method of claim l, Wherein: primary input information in Which the multiple pieces of control information areaggregated is presented in a first level, and secondary input information including each of the multiple pieces of control information for controlling each of the multiple table sets is presented in a second level.
    [3] 3. The method of claim 1, Wherein each of the lookup tables uses dependent variable values for a change in the single independent variable.
    [4] 4. The method of claim 2, Wherein the primary input information includes anumber of the multiple table sets included in the engineering database and names forreferring to respective pieces of the control information included in the engineering database.
    [5] 5. The method of claim 2, Wherein in the second level, values of remainingindependent variables, excluding the single independent variable included in themultiple lookup tables, are arranged along With names of the lookup tables in order to enable the multiple lookup tables to be sorted.
    [6] 6. The method of claim 2, Wherein the secondary input information includes a number of columns contained in the lookup table, a number of columns selected fromamong the columns contained in the lookup table, and column numbers of the selected columns.
    [7] 7. The method of claim 2, Wherein the secondary input information includesindependent Variables, a number and names of Variables dependent on the independent Variables, and a number of the multiple lookup tables.
    [8] 8. The method of claim 7, Wherein each of the multiple lookup tables isconfigured With a combination of input information for the independent Variables and a name of the lookup table corresponding to the independent Variables.
    类似技术:
    公开号 | 公开日 | 专利标题
    US8843502B2|2014-09-23|Sorting a dataset of incrementally received data
    EP3547168A1|2019-10-02|Block chain based data processing method and device
    US9262330B2|2016-02-16|Column oriented in-memory page caching
    US8959519B2|2015-02-17|Processing hierarchical data in a map-reduce framework
    US8204912B2|2012-06-19|Insertion rate aware b-tree
    CN104462269A|2015-03-25|Isomerous database data exchange method and system
    Santos2018|AnthropMMD: An R package with a graphical user interface for the mean measure of divergence
    US20130262974A1|2013-10-03|Tabular widget with mergable cells
    US20180349339A1|2018-12-06|Creating a spreadsheet template for generating an end user spreadsheet with dynamic cell dimensions retrieved from a remote application
    US11249990B2|2022-02-15|Database management method and system, and electronic device
    US20160246825A1|2016-08-25|Columnar database processing method and apparatus
    SE1651437A1|2017-05-05|Method for generating database using lookup table
    US10282406B2|2019-05-07|System for modifying a table
    US20170242838A1|2017-08-24|Spreadsheet with Dynamic Cell Dimensions Generated by a Spreadsheet Template Based on Remote Application Values
    US11074246B2|2021-07-27|Cluster-based random walk processing
    US9268875B2|2016-02-23|Extensible content focus mode
    Wiktorski2019|NOSQL databases
    KR20220031197A|2022-03-11|Apparatus for displaying graph using complex unit time scale and method thereof
    US20210319044A1|2021-10-14|Shuffle-less Reclustering of Clustered Tables
    CN108241620B|2022-03-18|Query script generation method and device
    Seo2015|Introduction to big data
    Morawski et al.2021|Data Tiering Options with SAP HANA and Usage in a Hadoop Scenario
    Yang et al.2017|SDAC: Porting Scientific Data to Spark RDDs
    US9436602B2|2016-09-06|Method and industrial automation component for indirect memory addressing
    US20150066994A1|2015-03-05|Managing sharing relationship of tables
    同族专利:
    公开号 | 公开日
    DE102016121018A1|2017-05-04|
    US20170124215A1|2017-05-04|
    KR101656357B1|2016-09-09|
    IT201600110418A1|2018-05-03|
    US10289644B2|2019-05-14|
    引用文献:
    公开号 | 申请日 | 公开日 | 申请人 | 专利标题
    US5742738A|1988-05-20|1998-04-21|John R. Koza|Simultaneous evolution of the architecture of a multi-part program to solve a problem using architecture altering operations|
    JPH07262018A|1994-03-25|1995-10-13|Toshiba Corp|Structuralized knowledge data base preparing method|
    JP3260632B2|1996-09-03|2002-02-25|エヌイーシーソフト株式会社|Multiple data format table management method|
    CA2197517C|1997-02-13|2002-01-15|Mitel Corporation|Database access server for pbx|
    US6202070B1|1997-12-31|2001-03-13|Compaq Computer Corporation|Computer manufacturing system architecture with enhanced software distribution functions|
    US6035303A|1998-02-02|2000-03-07|International Business Machines Corporation|Object management system for digital libraries|
    US6633875B2|1999-12-30|2003-10-14|Shaun Michael Brady|Computer database system and method for collecting and reporting real estate property and loan performance information over a computer driven network|
    US8386456B1|2000-02-24|2013-02-26|Richard Paiz|Codex search patterns|
    US20060129691A1|2000-09-11|2006-06-15|Grid Data, Inc.|Location aware wireless data gateway|
    US7146603B2|2001-01-05|2006-12-05|Borland Software Corporation|Context programming in object-oriented environments|
    US7693917B2|2001-11-30|2010-04-06|Intelligent Medical Objects, Inc.|Method for adaptive data management|
    US7260570B2|2002-02-01|2007-08-21|International Business Machines Corporation|Retrieving matching documents by queries in any national language|
    US8321470B2|2003-06-20|2012-11-27|International Business Machines Corporation|Heterogeneous multi-level extendable indexing for general purpose annotation systems|
    GB2409133A|2003-12-11|2005-06-15|Motorola Inc|Interleaver for a turbo encoder and decoder|
    JP2007536634A|2004-05-04|2007-12-13|フィッシャー−ローズマウント・システムズ・インコーポレーテッド|Service-oriented architecture for process control systems|
    EP1791340A3|2005-10-07|2007-07-25|Seiko Epson Corporation|Printer and image processing apparatus for printing raw data|
    US9081981B2|2005-12-29|2015-07-14|Nextlabs, Inc.|Techniques and system to manage access of information using policies|
    US20120278249A1|2011-04-29|2012-11-01|American Express Travel Related Services Company, Inc.|Generating an Identity Theft Score|
    US8954461B2|2011-09-30|2015-02-10|Oracle International Corporation|Systems and methods for object to relational mapping extensions|
    US9244961B2|2012-12-14|2016-01-26|Oracle International Corporation|Concurrent access for hierarchical data storage|
    US9268807B2|2013-07-17|2016-02-23|Sybase, Inc.|In-memory bitmap for column store operations|
    US9639542B2|2014-02-14|2017-05-02|Sap Se|Dynamic mapping of extensible datasets to relational database schemas|
    US10162848B2|2014-06-11|2018-12-25|Ureveal, Inc.|Methods and apparatus for harmonization of data stored in multiple databases using concept-based analysis|
    法律状态:
    2021-01-19| NAV| Patent application has lapsed|
    优先权:
    申请号 | 申请日 | 专利标题
    KR1020150154502A|KR101656357B1|2015-11-04|2015-11-04|Method for generating database using look up table|
    [返回顶部]